﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="ArtVideoList.aspx.vb" Inherits="_3dBuzz.ArtVideoList" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <p>
        &nbsp;</p>
    <p>
        Selected artist:   
  
       <!--  <asp:TextBox ID="tb_ArtistNickname" runat="server"  Text='<%# Eval("Nickname") %>' Enabled="False"> </asp:TextBox>  -->
       

&nbsp;<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
            BorderStyle="None" ShowHeader="False" >
            <Columns>
                <asp:BoundField DataField="Nickname" HeaderText="Nickname" 
                    SortExpression="Nickname" />
            </Columns>
        </asp:GridView>

        

        <br />
    </p>
    <p>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"     >
            <Columns>
                <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" >
                <HeaderStyle CssClass="columnhead" />
                </asp:BoundField>
                <asp:BoundField DataField="OriginalFilename" HeaderText="Filename" 
                    SortExpression="OriginalFilename" >
                <HeaderStyle CssClass="columnhead" />
                </asp:BoundField>
                <asp:HyperLinkField DataNavigateUrlFields="VideoId" 
                    DataNavigateUrlFormatString="VideoDetail.aspx?VideoId={0}" 
                    HeaderText="Select Video" Text="Select" >
                <HeaderStyle CssClass="columnhead" />
                </asp:HyperLinkField>
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:3dBuzzDatabase %>" 
            ProviderName="<%$ ConnectionStrings:3dBuzzDatabase.ProviderName %>" 
            
            
            SelectCommand="SELECT Video.[VideoId], Video.[Showreel], Video.[ArtistId], Video.[Title], Video.[OriginalFilename], Artists.[Nickname] 
            FROM Artists INNER JOIN [Video] ON Artists.[ID] = Video.[ArtistId] WHERE (Video.[ArtistId] = ?)">
            <SelectParameters>
                <asp:QueryStringParameter Name="ArtistId" QueryStringField="ArtistId" 
                    Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
    </p>
    <p>
      
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
     
    
</asp:Content>
